package com.autumn.zero.workflow.entitys.querys;

import javax.persistence.Table;

import com.autumn.mybatis.mapper.annotation.ViewTable;

/**
 * 用户待办查询
 * 
 * @author 杨昌国 2019-02-26 11:28:31
 */
@Table
@ViewTable(WorkflowUserTaskWaitQuery.QUERY_COMMAND_TEXT)
public class WorkflowUserTaskWaitQuery extends AbstractWorkflowUserTaskQuery {

	/**
	 * 
	 */
	private static final long serialVersionUID = -1063529562206508817L;
	/**
	 * 
	 */
	static final String QUERY_COMMAND_TEXT = "SELECT a.id,a.flow_process_id,a.task_no,a.user_id,a.task_name,a.task_time,a.task_summary,a.gmt_create,b.form_type,b.form_id,b.form_no,b.form_name,b.flow_title,b.process_instance_id,b.start_user_name FROM sys_workflow_user_task_wait AS a INNER JOIN sys_workflow_process AS b ON a.flow_process_id = b.id";
}
